package com.chixing.mapper;

import com.chixing.entity.Employee;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDate;
import java.util.List;

public interface EmployeeMapper extends BaseMapper<Employee> {
    public  List<Employee> selectByMoreConditions(@Param("empno") Integer empno,
                                                  @Param("empName")  String empName,
                                                  @Param("empJob")  String empJob,
                                                  @Param("managerNo")  Integer managerNo,
                                                  @Param("empHiredate")  LocalDate empHiredate,
                                                  @Param("empSalary")  Float empSalary,
                                                  @Param("empComm")  Float empComm,
                                                  @Param("deptno")  Integer deptno,
                                                  @Param("minSalary")Float minSalary,
                                                  @Param("maxSalary")Float maxSalary);
    //包含查询select * from emp where deptno in(10,20,30);
    public List<Employee> selectDeptnos(List<Integer> deptnoList);

    //模糊查询select * from emp where ename like '%A%'
    public  List<Employee> selectByName(String ename);


}
